{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from pandas.tseries.offsets import *\n",
    "from xiao_utils import f"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 注意要把表中的 0 也都按空值 nan 处理，因为实际上不可能有真正有意义的 0 出现的！\n",
    "df_CB = pd.read_csv(\"../../data/features/CB_features.csv\", dtype={'sale_date':str}, na_values=['-',0], low_memory=False)\n",
    "df_CB['sale_date']= pd.to_datetime(df_CB['sale_date'])\n",
    "# df_C = df_C.drop('C_rcm_0', axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_OC = pd.read_csv(\"../../data/features/OC_features_online.csv\", dtype={'sale_date':str}, na_values=['-',0], low_memory=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>class_id</th>\n",
       "      <th>sale_date</th>\n",
       "      <th>sale_quantity</th>\n",
       "      <th>C_som_1</th>\n",
       "      <th>C_som_2</th>\n",
       "      <th>C_som_3</th>\n",
       "      <th>C_som_4</th>\n",
       "      <th>C_som_5</th>\n",
       "      <th>C_som_6</th>\n",
       "      <th>C_som_7</th>\n",
       "      <th>...</th>\n",
       "      <th>CB_sdy_3</th>\n",
       "      <th>CB_sry_1</th>\n",
       "      <th>CB_sry_2</th>\n",
       "      <th>CB_sry_3</th>\n",
       "      <th>CB_dfry_1</th>\n",
       "      <th>CB_dfry_2</th>\n",
       "      <th>CB_dfry_3</th>\n",
       "      <th>CB_rfdy_1</th>\n",
       "      <th>CB_rfdy_2</th>\n",
       "      <th>CB_rfdy_3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-03-01</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-04-01</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-05-01</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-06-01</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-07-01</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-08-01</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-09-01</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-10-01</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-11-01</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-12-01</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-02-01</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-03-01</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-04-01</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-05-01</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-08-01</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-10-01</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-11-01</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-12-01</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-02-01</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-03-01</td>\n",
       "      <td>371.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>121.959328</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-04-01</td>\n",
       "      <td>290.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.061227</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-05-01</td>\n",
       "      <td>429.0</td>\n",
       "      <td>290.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.673481</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-06-01</td>\n",
       "      <td>371.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>290.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.196314</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-07-01</td>\n",
       "      <td>313.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>290.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.558442</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-08-01</td>\n",
       "      <td>180.0</td>\n",
       "      <td>313.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>290.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.969718</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5697</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-06-01</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>799.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>439.0</td>\n",
       "      <td>447.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5698</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-07-01</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>799.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>439.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5699</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-08-01</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>799.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5700</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-09-01</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>799.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5701</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-10-01</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5702</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-11-01</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5703</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-12-01</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5704</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5705</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-02-01</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5706</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-03-01</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5707</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-04-01</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5708</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-05-01</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5709</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5710</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5711</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-08-01</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.894834</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5712</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.800519</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5713</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-10-01</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.755889</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5714</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-11-01</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.748674</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5715</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-12-01</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.884644</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5716</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.398538</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5717</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-02-01</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.017404</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5718</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-03-01</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.624303</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5719</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-04-01</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.703107</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5720</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-05-01</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.953906</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5721</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-06-01</td>\n",
       "      <td>381.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.407401</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5722</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-07-01</td>\n",
       "      <td>270.0</td>\n",
       "      <td>381.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.417262</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5723</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-08-01</td>\n",
       "      <td>419.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>381.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.714347</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.912256</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.058475</td>\n",
       "      <td>0.894834</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5724</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-09-01</td>\n",
       "      <td>401.0</td>\n",
       "      <td>419.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>381.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.253968</td>\n",
       "      <td>0.448043</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.121967</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.700739</td>\n",
       "      <td>0.800519</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5725</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-10-01</td>\n",
       "      <td>400.0</td>\n",
       "      <td>401.0</td>\n",
       "      <td>419.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>381.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.988688</td>\n",
       "      <td>0.395820</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.137587</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.499586</td>\n",
       "      <td>0.755889</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5726</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>400.0</td>\n",
       "      <td>401.0</td>\n",
       "      <td>419.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>381.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.244627</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.780727</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.270844</td>\n",
       "      <td>0.748674</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5727 rows × 1456 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      class_id  sale_date  sale_quantity  C_som_1  C_som_2  C_som_3  C_som_4  \\\n",
       "0       103507 2015-03-01           58.0      NaN      NaN      NaN      NaN   \n",
       "1       103507 2015-04-01          232.0     58.0      NaN      NaN      NaN   \n",
       "2       103507 2015-05-01          226.0    232.0     58.0      NaN      NaN   \n",
       "3       103507 2015-06-01          286.0    226.0    232.0     58.0      NaN   \n",
       "4       103507 2015-07-01          297.0    286.0    226.0    232.0     58.0   \n",
       "5       103507 2015-08-01          355.0    297.0    286.0    226.0    232.0   \n",
       "6       103507 2015-09-01          442.0    355.0    297.0    286.0    226.0   \n",
       "7       103507 2015-10-01         1050.0    442.0    355.0    297.0    286.0   \n",
       "8       103507 2015-11-01          481.0   1050.0    442.0    355.0    297.0   \n",
       "9       103507 2015-12-01         1433.0    481.0   1050.0    442.0    355.0   \n",
       "10      103507 2016-01-01          993.0   1433.0    481.0   1050.0    442.0   \n",
       "11      103507 2016-02-01          953.0    993.0   1433.0    481.0   1050.0   \n",
       "12      103507 2016-03-01          650.0    953.0    993.0   1433.0    481.0   \n",
       "13      103507 2016-04-01          145.0    650.0    953.0    993.0   1433.0   \n",
       "14      103507 2016-05-01          772.0    145.0    650.0    953.0    993.0   \n",
       "15      103507 2016-06-01          829.0    772.0    145.0    650.0    953.0   \n",
       "16      103507 2016-07-01          378.0    829.0    772.0    145.0    650.0   \n",
       "17      103507 2016-08-01          406.0    378.0    829.0    772.0    145.0   \n",
       "18      103507 2016-09-01          684.0    406.0    378.0    829.0    772.0   \n",
       "19      103507 2016-10-01          632.0    684.0    406.0    378.0    829.0   \n",
       "20      103507 2016-11-01          876.0    632.0    684.0    406.0    378.0   \n",
       "21      103507 2016-12-01         1653.0    876.0    632.0    684.0    406.0   \n",
       "22      103507 2017-01-01          499.0   1653.0    876.0    632.0    684.0   \n",
       "23      103507 2017-02-01          435.0    499.0   1653.0    876.0    632.0   \n",
       "24      103507 2017-03-01          371.0    435.0    499.0   1653.0    876.0   \n",
       "25      103507 2017-04-01          290.0    371.0    435.0    499.0   1653.0   \n",
       "26      103507 2017-05-01          429.0    290.0    371.0    435.0    499.0   \n",
       "27      103507 2017-06-01          371.0    429.0    290.0    371.0    435.0   \n",
       "28      103507 2017-07-01          313.0    371.0    429.0    290.0    371.0   \n",
       "29      103507 2017-08-01          180.0    313.0    371.0    429.0    290.0   \n",
       "...        ...        ...            ...      ...      ...      ...      ...   \n",
       "5697    978089 2015-06-01          372.0    418.0    260.0    429.0    799.0   \n",
       "5698    978089 2015-07-01          428.0    372.0    418.0    260.0    429.0   \n",
       "5699    978089 2015-08-01          503.0    428.0    372.0    418.0    260.0   \n",
       "5700    978089 2015-09-01          753.0    503.0    428.0    372.0    418.0   \n",
       "5701    978089 2015-10-01          790.0    753.0    503.0    428.0    372.0   \n",
       "5702    978089 2015-11-01          659.0    790.0    753.0    503.0    428.0   \n",
       "5703    978089 2015-12-01         1284.0    659.0    790.0    753.0    503.0   \n",
       "5704    978089 2016-01-01          651.0   1284.0    659.0    790.0    753.0   \n",
       "5705    978089 2016-02-01          623.0    651.0   1284.0    659.0    790.0   \n",
       "5706    978089 2016-03-01          605.0    623.0    651.0   1284.0    659.0   \n",
       "5707    978089 2016-04-01          604.0    605.0    623.0    651.0   1284.0   \n",
       "5708    978089 2016-05-01          735.0    604.0    605.0    623.0    651.0   \n",
       "5709    978089 2016-06-01          474.0    735.0    604.0    605.0    623.0   \n",
       "5710    978089 2016-07-01          530.0    474.0    735.0    604.0    605.0   \n",
       "5711    978089 2016-08-01          521.0    530.0    474.0    735.0    604.0   \n",
       "5712    978089 2016-09-01          474.0    521.0    530.0    474.0    735.0   \n",
       "5713    978089 2016-10-01          503.0    474.0    521.0    530.0    474.0   \n",
       "5714    978089 2016-11-01          400.0    503.0    474.0    521.0    530.0   \n",
       "5715    978089 2016-12-01         1042.0    400.0    503.0    474.0    521.0   \n",
       "5716    978089 2017-01-01          558.0   1042.0    400.0    503.0    474.0   \n",
       "5717    978089 2017-02-01          494.0    558.0   1042.0    400.0    503.0   \n",
       "5718    978089 2017-03-01          548.0    494.0    558.0   1042.0    400.0   \n",
       "5719    978089 2017-04-01          466.0    548.0    494.0    558.0   1042.0   \n",
       "5720    978089 2017-05-01          512.0    466.0    548.0    494.0    558.0   \n",
       "5721    978089 2017-06-01          381.0    512.0    466.0    548.0    494.0   \n",
       "5722    978089 2017-07-01          270.0    381.0    512.0    466.0    548.0   \n",
       "5723    978089 2017-08-01          419.0    270.0    381.0    512.0    466.0   \n",
       "5724    978089 2017-09-01          401.0    419.0    270.0    381.0    512.0   \n",
       "5725    978089 2017-10-01          400.0    401.0    419.0    270.0    381.0   \n",
       "5726    978089 2017-11-01            NaN    400.0    401.0    419.0    270.0   \n",
       "\n",
       "      C_som_5  C_som_6  C_som_7    ...      CB_sdy_3  CB_sry_1  CB_sry_2  \\\n",
       "0         NaN      NaN      NaN    ...           NaN       NaN       NaN   \n",
       "1         NaN      NaN      NaN    ...           NaN       NaN       NaN   \n",
       "2         NaN      NaN      NaN    ...           NaN       NaN       NaN   \n",
       "3         NaN      NaN      NaN    ...           NaN       NaN       NaN   \n",
       "4         NaN      NaN      NaN    ...           NaN       NaN       NaN   \n",
       "5        58.0      NaN      NaN    ...           NaN       NaN       NaN   \n",
       "6       232.0     58.0      NaN    ...           NaN       NaN       NaN   \n",
       "7       226.0    232.0     58.0    ...           NaN       NaN       NaN   \n",
       "8       286.0    226.0    232.0    ...           NaN       NaN       NaN   \n",
       "9       297.0    286.0    226.0    ...           NaN       NaN       NaN   \n",
       "10      355.0    297.0    286.0    ...           NaN       NaN       NaN   \n",
       "11      442.0    355.0    297.0    ...           NaN       NaN       NaN   \n",
       "12     1050.0    442.0    355.0    ...           NaN       NaN       NaN   \n",
       "13      481.0   1050.0    442.0    ...           NaN       NaN       NaN   \n",
       "14     1433.0    481.0   1050.0    ...           NaN       NaN       NaN   \n",
       "15      993.0   1433.0    481.0    ...           NaN       NaN       NaN   \n",
       "16      953.0    993.0   1433.0    ...           NaN       NaN       NaN   \n",
       "17      650.0    953.0    993.0    ...           NaN       NaN       NaN   \n",
       "18      145.0    650.0    953.0    ...           NaN       NaN       NaN   \n",
       "19      772.0    145.0    650.0    ...           NaN       NaN       NaN   \n",
       "20      829.0    772.0    145.0    ...           NaN       NaN       NaN   \n",
       "21      378.0    829.0    772.0    ...           NaN       NaN       NaN   \n",
       "22      406.0    378.0    829.0    ...           NaN       NaN       NaN   \n",
       "23      684.0    406.0    378.0    ...           NaN       NaN       NaN   \n",
       "24      632.0    684.0    406.0    ...           NaN       NaN       NaN   \n",
       "25      876.0    632.0    684.0    ...           NaN       NaN       NaN   \n",
       "26     1653.0    876.0    632.0    ...           NaN       NaN       NaN   \n",
       "27      499.0   1653.0    876.0    ...           NaN       NaN       NaN   \n",
       "28      435.0    499.0   1653.0    ...           NaN       NaN       NaN   \n",
       "29      371.0    435.0    499.0    ...           NaN       NaN       NaN   \n",
       "...       ...      ...      ...    ...           ...       ...       ...   \n",
       "5697    800.0    439.0    447.0    ...           NaN       NaN       NaN   \n",
       "5698    799.0    800.0    439.0    ...           NaN       NaN       NaN   \n",
       "5699    429.0    799.0    800.0    ...           NaN       NaN       NaN   \n",
       "5700    260.0    429.0    799.0    ...           NaN       NaN       NaN   \n",
       "5701    418.0    260.0    429.0    ...           NaN       NaN       NaN   \n",
       "5702    372.0    418.0    260.0    ...           NaN       NaN       NaN   \n",
       "5703    428.0    372.0    418.0    ...           NaN       NaN       NaN   \n",
       "5704    503.0    428.0    372.0    ...           NaN       NaN       NaN   \n",
       "5705    753.0    503.0    428.0    ...           NaN       NaN       NaN   \n",
       "5706    790.0    753.0    503.0    ...           NaN       NaN       NaN   \n",
       "5707    659.0    790.0    753.0    ...           NaN       NaN       NaN   \n",
       "5708   1284.0    659.0    790.0    ...           NaN       NaN       NaN   \n",
       "5709    651.0   1284.0    659.0    ...           NaN       NaN       NaN   \n",
       "5710    623.0    651.0   1284.0    ...           NaN       NaN       NaN   \n",
       "5711    605.0    623.0    651.0    ...           NaN       NaN       NaN   \n",
       "5712    604.0    605.0    623.0    ...           NaN       NaN       NaN   \n",
       "5713    735.0    604.0    605.0    ...           NaN       NaN       NaN   \n",
       "5714    474.0    735.0    604.0    ...           NaN       NaN       NaN   \n",
       "5715    530.0    474.0    735.0    ...           NaN       NaN       NaN   \n",
       "5716    521.0    530.0    474.0    ...           NaN       NaN       NaN   \n",
       "5717    474.0    521.0    530.0    ...           NaN       NaN       NaN   \n",
       "5718    503.0    474.0    521.0    ...           NaN       NaN       NaN   \n",
       "5719    400.0    503.0    474.0    ...           NaN       NaN       NaN   \n",
       "5720   1042.0    400.0    503.0    ...           NaN       NaN       NaN   \n",
       "5721    558.0   1042.0    400.0    ...           NaN       NaN       NaN   \n",
       "5722    494.0    558.0   1042.0    ...           NaN       NaN       NaN   \n",
       "5723    548.0    494.0    558.0    ...      1.000000  0.714347       NaN   \n",
       "5724    466.0    548.0    494.0    ...      1.253968  0.448043       NaN   \n",
       "5725    512.0    466.0    548.0    ...      0.988688  0.395820       NaN   \n",
       "5726    381.0    512.0    466.0    ...      1.000000  0.244627       NaN   \n",
       "\n",
       "      CB_sry_3  CB_dfry_1  CB_dfry_2  CB_dfry_3   CB_rfdy_1  CB_rfdy_2  \\\n",
       "0          NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "1          NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "2          NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "3          NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "4          NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5          NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "6          NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "7          NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "8          NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "9          NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "10         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "11         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "12         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "13         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "14         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "15         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "16         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "17         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "18         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "19         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "20         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "21         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "22         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "23         NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "24         NaN        NaN        NaN        NaN  121.959328        NaN   \n",
       "25         NaN        NaN        NaN        NaN    0.061227        NaN   \n",
       "26         NaN        NaN        NaN        NaN    1.673481        NaN   \n",
       "27         NaN        NaN        NaN        NaN    0.196314        NaN   \n",
       "28         NaN        NaN        NaN        NaN    7.558442        NaN   \n",
       "29         NaN        NaN        NaN        NaN    0.969718        NaN   \n",
       "...        ...        ...        ...        ...         ...        ...   \n",
       "5697       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5698       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5699       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5700       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5701       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5702       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5703       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5704       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5705       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5706       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5707       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5708       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5709       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5710       NaN        NaN        NaN        NaN         NaN        NaN   \n",
       "5711       NaN        NaN        NaN        NaN    0.894834        NaN   \n",
       "5712       NaN        NaN        NaN        NaN    0.800519        NaN   \n",
       "5713       NaN        NaN        NaN        NaN    0.755889        NaN   \n",
       "5714       NaN        NaN        NaN        NaN    0.748674        NaN   \n",
       "5715       NaN        NaN        NaN        NaN    0.884644        NaN   \n",
       "5716       NaN        NaN        NaN        NaN    1.398538        NaN   \n",
       "5717       NaN        NaN        NaN        NaN    1.017404        NaN   \n",
       "5718       NaN        NaN        NaN        NaN    0.624303        NaN   \n",
       "5719       NaN        NaN        NaN        NaN    0.703107        NaN   \n",
       "5720       NaN        NaN        NaN        NaN    0.953906        NaN   \n",
       "5721       NaN        NaN        NaN        NaN    0.407401        NaN   \n",
       "5722       NaN        NaN        NaN        NaN    0.417262        NaN   \n",
       "5723       NaN   0.912256        NaN        NaN    0.058475   0.894834   \n",
       "5724       NaN   1.121967        NaN        NaN   -0.700739   0.800519   \n",
       "5725       NaN   5.137587        NaN        NaN   -0.499586   0.755889   \n",
       "5726       NaN  -0.780727        NaN        NaN   -0.270844   0.748674   \n",
       "\n",
       "      CB_rfdy_3  \n",
       "0           NaN  \n",
       "1           NaN  \n",
       "2           NaN  \n",
       "3           NaN  \n",
       "4           NaN  \n",
       "5           NaN  \n",
       "6           NaN  \n",
       "7           NaN  \n",
       "8           NaN  \n",
       "9           NaN  \n",
       "10          NaN  \n",
       "11          NaN  \n",
       "12          NaN  \n",
       "13          NaN  \n",
       "14          NaN  \n",
       "15          NaN  \n",
       "16          NaN  \n",
       "17          NaN  \n",
       "18          NaN  \n",
       "19          NaN  \n",
       "20          NaN  \n",
       "21          NaN  \n",
       "22          NaN  \n",
       "23          NaN  \n",
       "24          NaN  \n",
       "25          NaN  \n",
       "26          NaN  \n",
       "27          NaN  \n",
       "28          NaN  \n",
       "29          NaN  \n",
       "...         ...  \n",
       "5697        NaN  \n",
       "5698        NaN  \n",
       "5699        NaN  \n",
       "5700        NaN  \n",
       "5701        NaN  \n",
       "5702        NaN  \n",
       "5703        NaN  \n",
       "5704        NaN  \n",
       "5705        NaN  \n",
       "5706        NaN  \n",
       "5707        NaN  \n",
       "5708        NaN  \n",
       "5709        NaN  \n",
       "5710        NaN  \n",
       "5711        NaN  \n",
       "5712        NaN  \n",
       "5713        NaN  \n",
       "5714        NaN  \n",
       "5715        NaN  \n",
       "5716        NaN  \n",
       "5717        NaN  \n",
       "5718        NaN  \n",
       "5719        NaN  \n",
       "5720        NaN  \n",
       "5721        NaN  \n",
       "5722        NaN  \n",
       "5723        NaN  \n",
       "5724        NaN  \n",
       "5725        NaN  \n",
       "5726        NaN  \n",
       "\n",
       "[5727 rows x 1456 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_CB"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>class_id</th>\n",
       "      <th>OC_mode_compartment</th>\n",
       "      <th>OC_mode_displacement</th>\n",
       "      <th>OC_mode_price_level</th>\n",
       "      <th>OC_mode_price</th>\n",
       "      <th>OC_mode_emission_standards_id</th>\n",
       "      <th>OC_mode_power</th>\n",
       "      <th>OC_mode_cylinder_number</th>\n",
       "      <th>OC_mode_engine_torque</th>\n",
       "      <th>OC_mode_car_length</th>\n",
       "      <th>...</th>\n",
       "      <th>OC_mode_driven_type_id_2</th>\n",
       "      <th>OC_mode_driven_type_id_3</th>\n",
       "      <th>OC_mode_fuel_type_id_1.0</th>\n",
       "      <th>OC_mode_fuel_type_id_4.0</th>\n",
       "      <th>OC_mode_newenergy_type_id_1</th>\n",
       "      <th>OC_mode_newenergy_type_id_3</th>\n",
       "      <th>OC_mode_if_MPV_id_1</th>\n",
       "      <th>OC_mode_if_MPV_id_2</th>\n",
       "      <th>OC_mode_if_luxurious_id_1</th>\n",
       "      <th>OC_mode_if_luxurious_id_2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>103507</td>\n",
       "      <td>2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>91.6</td>\n",
       "      <td>4.0</td>\n",
       "      <td>150.7</td>\n",
       "      <td>4270</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>124140</td>\n",
       "      <td>2</td>\n",
       "      <td>1.8</td>\n",
       "      <td>3.0</td>\n",
       "      <td>13.3</td>\n",
       "      <td>1</td>\n",
       "      <td>130.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>230.0</td>\n",
       "      <td>4650</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>125403</td>\n",
       "      <td>2</td>\n",
       "      <td>2.4</td>\n",
       "      <td>7.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>1</td>\n",
       "      <td>120.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>5213</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>136916</td>\n",
       "      <td>3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>23.1</td>\n",
       "      <td>3</td>\n",
       "      <td>123.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>4825</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>169673</td>\n",
       "      <td>2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1</td>\n",
       "      <td>110.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>215.0</td>\n",
       "      <td>4715</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>175962</td>\n",
       "      <td>3</td>\n",
       "      <td>1.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.6</td>\n",
       "      <td>3</td>\n",
       "      <td>81.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4473</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>178529</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.1</td>\n",
       "      <td>3</td>\n",
       "      <td>45.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>3730</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>186250</td>\n",
       "      <td>2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15.2</td>\n",
       "      <td>1</td>\n",
       "      <td>84.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>146.0</td>\n",
       "      <td>4370</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>194201</td>\n",
       "      <td>2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.2</td>\n",
       "      <td>1</td>\n",
       "      <td>73.3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>132.4</td>\n",
       "      <td>4240</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>194450</td>\n",
       "      <td>2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>4.0</td>\n",
       "      <td>11.4</td>\n",
       "      <td>1</td>\n",
       "      <td>130.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>265.0</td>\n",
       "      <td>4475</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>198427</td>\n",
       "      <td>3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>41.2</td>\n",
       "      <td>1</td>\n",
       "      <td>80.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>4547</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>206765</td>\n",
       "      <td>3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>10.1</td>\n",
       "      <td>1</td>\n",
       "      <td>84.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>146.0</td>\n",
       "      <td>4718</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>209945</td>\n",
       "      <td>3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>26.8</td>\n",
       "      <td>1</td>\n",
       "      <td>178.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>310.0</td>\n",
       "      <td>5055</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>219195</td>\n",
       "      <td>2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15.4</td>\n",
       "      <td>1</td>\n",
       "      <td>110.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>210.0</td>\n",
       "      <td>4335</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>221795</td>\n",
       "      <td>2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1</td>\n",
       "      <td>110.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4385</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>245609</td>\n",
       "      <td>2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>4.0</td>\n",
       "      <td>25.9</td>\n",
       "      <td>1</td>\n",
       "      <td>96.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>4348</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>248352</td>\n",
       "      <td>3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>2.0</td>\n",
       "      <td>16.6</td>\n",
       "      <td>3</td>\n",
       "      <td>78.7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>4370</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>249875</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>18.3</td>\n",
       "      <td>1</td>\n",
       "      <td>110.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>4672</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>250658</td>\n",
       "      <td>3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>21.1</td>\n",
       "      <td>1</td>\n",
       "      <td>120.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>252.0</td>\n",
       "      <td>4923</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>265980</td>\n",
       "      <td>2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.5</td>\n",
       "      <td>3</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>4360</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>270690</td>\n",
       "      <td>2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1</td>\n",
       "      <td>82.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>146.5</td>\n",
       "      <td>4415</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>281301</td>\n",
       "      <td>3</td>\n",
       "      <td>1.8</td>\n",
       "      <td>6.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1</td>\n",
       "      <td>118.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4870</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>281792</td>\n",
       "      <td>3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>6.0</td>\n",
       "      <td>15.8</td>\n",
       "      <td>1</td>\n",
       "      <td>110.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4462</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>289386</td>\n",
       "      <td>3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.2</td>\n",
       "      <td>1</td>\n",
       "      <td>86.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>4582</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>289403</td>\n",
       "      <td>2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.9</td>\n",
       "      <td>1</td>\n",
       "      <td>95.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>185.0</td>\n",
       "      <td>4440</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>290854</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.8</td>\n",
       "      <td>3</td>\n",
       "      <td>114.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>4550</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>291086</td>\n",
       "      <td>3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>15.2</td>\n",
       "      <td>1</td>\n",
       "      <td>108.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>4843</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>291514</td>\n",
       "      <td>2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>13.7</td>\n",
       "      <td>3</td>\n",
       "      <td>92.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>4160</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>302513</td>\n",
       "      <td>2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.5</td>\n",
       "      <td>1</td>\n",
       "      <td>88.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>4354</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>304458</td>\n",
       "      <td>3</td>\n",
       "      <td>1.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11.2</td>\n",
       "      <td>1</td>\n",
       "      <td>90.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>154.0</td>\n",
       "      <td>4630</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>745137</td>\n",
       "      <td>3</td>\n",
       "      <td>1.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>35.3</td>\n",
       "      <td>1</td>\n",
       "      <td>92.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>215.0</td>\n",
       "      <td>4534</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>750340</td>\n",
       "      <td>2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>13.9</td>\n",
       "      <td>1</td>\n",
       "      <td>115.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>201.0</td>\n",
       "      <td>4530</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>760412</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>13.5</td>\n",
       "      <td>1</td>\n",
       "      <td>122.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>155.5</td>\n",
       "      <td>4705</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>786351</td>\n",
       "      <td>3</td>\n",
       "      <td>1.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>25.2</td>\n",
       "      <td>3</td>\n",
       "      <td>93.8</td>\n",
       "      <td>4.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>4570</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>789290</td>\n",
       "      <td>3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>18.6</td>\n",
       "      <td>1</td>\n",
       "      <td>79.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4440</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>810398</td>\n",
       "      <td>2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>1</td>\n",
       "      <td>81.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4282</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>815230</td>\n",
       "      <td>2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.2</td>\n",
       "      <td>1</td>\n",
       "      <td>121.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>4415</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>819061</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.4</td>\n",
       "      <td>3</td>\n",
       "      <td>121.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>245.0</td>\n",
       "      <td>4450</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>842246</td>\n",
       "      <td>2</td>\n",
       "      <td>1.8</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.5</td>\n",
       "      <td>1</td>\n",
       "      <td>130.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>4748</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>851857</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.4</td>\n",
       "      <td>1</td>\n",
       "      <td>179.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>4812</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>854079</td>\n",
       "      <td>3</td>\n",
       "      <td>1.8</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18.5</td>\n",
       "      <td>3</td>\n",
       "      <td>102.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>4650</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>854548</td>\n",
       "      <td>2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>1</td>\n",
       "      <td>88.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4314</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>861459</td>\n",
       "      <td>3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.7</td>\n",
       "      <td>1</td>\n",
       "      <td>124.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>4671</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>871642</td>\n",
       "      <td>2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1</td>\n",
       "      <td>133.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>360.0</td>\n",
       "      <td>4524</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>872180</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16.9</td>\n",
       "      <td>1</td>\n",
       "      <td>172.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4765</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>883691</td>\n",
       "      <td>3</td>\n",
       "      <td>1.8</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12.3</td>\n",
       "      <td>1</td>\n",
       "      <td>118.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>146.5</td>\n",
       "      <td>4865</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>890189</td>\n",
       "      <td>2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>1</td>\n",
       "      <td>82.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>4220</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>905061</td>\n",
       "      <td>2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.3</td>\n",
       "      <td>1</td>\n",
       "      <td>92.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>4810</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>905745</td>\n",
       "      <td>2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>3.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>1</td>\n",
       "      <td>103.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4278</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>914348</td>\n",
       "      <td>2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.9</td>\n",
       "      <td>1</td>\n",
       "      <td>81.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>3970</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>923841</td>\n",
       "      <td>3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>108.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>142.0</td>\n",
       "      <td>4869</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>924154</td>\n",
       "      <td>3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>85.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>4587</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>948936</td>\n",
       "      <td>2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>83.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4520</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>950264</td>\n",
       "      <td>2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>124.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>265.0</td>\n",
       "      <td>4545</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>953842</td>\n",
       "      <td>2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>130.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>4480</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>961362</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>106.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>4315</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>961962</td>\n",
       "      <td>3</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>81.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>150.7</td>\n",
       "      <td>4487</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>963845</td>\n",
       "      <td>2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>91.6</td>\n",
       "      <td>4.0</td>\n",
       "      <td>243.0</td>\n",
       "      <td>4270</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>973106</td>\n",
       "      <td>2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>142.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>4816</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>978089</td>\n",
       "      <td>3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>80.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4631</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>140 rows × 223 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     class_id  OC_mode_compartment  OC_mode_displacement  OC_mode_price_level  \\\n",
       "0      103507                    2                   1.6                  3.0   \n",
       "1      124140                    2                   1.8                  3.0   \n",
       "2      125403                    2                   2.4                  7.0   \n",
       "3      136916                    3                   2.0                  4.0   \n",
       "4      169673                    2                   1.5                  1.0   \n",
       "5      175962                    3                   1.6                  3.0   \n",
       "6      178529                    1                   1.0                  NaN   \n",
       "7      186250                    2                   1.5                  3.0   \n",
       "8      194201                    2                   1.4                  2.0   \n",
       "9      194450                    2                   1.6                  4.0   \n",
       "10     198427                    3                   1.5                  1.0   \n",
       "11     206765                    3                   1.5                  4.0   \n",
       "12     209945                    3                   2.0                  7.0   \n",
       "13     219195                    2                   1.5                  3.0   \n",
       "14     221795                    2                   1.4                  6.0   \n",
       "15     245609                    2                   1.4                  4.0   \n",
       "16     248352                    3                   1.4                  2.0   \n",
       "17     249875                    2                   2.0                  5.0   \n",
       "18     250658                    3                   1.5                  4.0   \n",
       "19     265980                    2                   1.5                  1.0   \n",
       "20     270690                    2                   1.5                  NaN   \n",
       "21     281301                    3                   1.8                  6.0   \n",
       "22     281792                    3                   1.4                  6.0   \n",
       "23     289386                    3                   1.5                  3.0   \n",
       "24     289403                    2                   1.3                  2.0   \n",
       "25     290854                    2                   2.0                  4.0   \n",
       "26     291086                    3                   2.0                  5.0   \n",
       "27     291514                    2                   1.6                  2.0   \n",
       "28     302513                    2                   1.5                  1.0   \n",
       "29     304458                    3                   1.6                  3.0   \n",
       "..        ...                  ...                   ...                  ...   \n",
       "110    745137                    3                   1.6                  3.0   \n",
       "111    750340                    2                   1.5                  3.0   \n",
       "112    760412                    2                   2.0                  4.0   \n",
       "113    786351                    3                   1.6                  3.0   \n",
       "114    789290                    3                   1.5                  2.0   \n",
       "115    810398                    2                   1.6                  3.0   \n",
       "116    815230                    2                   1.4                  4.0   \n",
       "117    819061                    2                   2.0                  4.0   \n",
       "118    842246                    2                   1.8                  3.0   \n",
       "119    851857                    2                   2.0                  6.0   \n",
       "120    854079                    3                   1.8                  3.0   \n",
       "121    854548                    2                   1.5                  3.0   \n",
       "122    861459                    3                   1.5                  3.0   \n",
       "123    871642                    2                   1.5                  5.0   \n",
       "124    872180                    2                   2.0                  4.0   \n",
       "125    883691                    3                   1.8                  5.0   \n",
       "126    890189                    2                   1.5                  1.0   \n",
       "127    905061                    2                   1.6                  1.0   \n",
       "128    905745                    2                   1.4                  3.0   \n",
       "129    914348                    2                   1.6                  3.0   \n",
       "130    923841                    3                   2.0                  4.0   \n",
       "131    924154                    3                   1.5                  3.0   \n",
       "132    948936                    2                   1.5                  1.0   \n",
       "133    950264                    2                   1.5                  4.0   \n",
       "134    953842                    2                   1.6                  4.0   \n",
       "135    961362                    2                   2.0                  4.0   \n",
       "136    961962                    3                   1.6                  2.0   \n",
       "137    963845                    2                   1.6                  3.0   \n",
       "138    973106                    2                   1.5                  6.0   \n",
       "139    978089                    3                   1.5                  1.0   \n",
       "\n",
       "     OC_mode_price  OC_mode_emission_standards_id  OC_mode_power  \\\n",
       "0             10.0                              1           91.6   \n",
       "1             13.3                              1          130.0   \n",
       "2             45.0                              1          120.0   \n",
       "3             23.1                              3          123.0   \n",
       "4              8.0                              1          110.0   \n",
       "5              7.6                              3           81.0   \n",
       "6             12.1                              3           45.0   \n",
       "7             15.2                              1           84.0   \n",
       "8              5.2                              1           73.3   \n",
       "9             11.4                              1          130.0   \n",
       "10            41.2                              1           80.0   \n",
       "11            10.1                              1           84.0   \n",
       "12            26.8                              1          178.0   \n",
       "13            15.4                              1          110.0   \n",
       "14             6.0                              1          110.0   \n",
       "15            25.9                              1           96.0   \n",
       "16            16.6                              3           78.7   \n",
       "17            18.3                              1          110.0   \n",
       "18            21.1                              1          120.0   \n",
       "19            10.5                              3           78.0   \n",
       "20             9.0                              1           82.0   \n",
       "21            17.0                              1          118.0   \n",
       "22            15.8                              1          110.0   \n",
       "23             8.2                              1           86.0   \n",
       "24             8.9                              1           95.0   \n",
       "25             9.8                              3          114.0   \n",
       "26            15.2                              1          108.0   \n",
       "27            13.7                              3           92.0   \n",
       "28            10.5                              1           88.0   \n",
       "29            11.2                              1           90.0   \n",
       "..             ...                            ...            ...   \n",
       "110           35.3                              1           92.0   \n",
       "111           13.9                              1          115.0   \n",
       "112           13.5                              1          122.0   \n",
       "113           25.2                              3           93.8   \n",
       "114           18.6                              1           79.0   \n",
       "115           21.0                              1           81.0   \n",
       "116            6.2                              1          121.0   \n",
       "117            9.4                              3          121.0   \n",
       "118           12.5                              1          130.0   \n",
       "119            8.4                              1          179.0   \n",
       "120           18.5                              3          102.0   \n",
       "121            8.1                              1           88.0   \n",
       "122            6.7                              1          124.0   \n",
       "123           11.0                              1          133.0   \n",
       "124           16.9                              1          172.0   \n",
       "125           12.3                              1          118.0   \n",
       "126            8.1                              1           82.0   \n",
       "127           14.3                              1           92.0   \n",
       "128           28.0                              1          103.0   \n",
       "129            8.9                              1           81.0   \n",
       "130            NaN                              1          108.0   \n",
       "131            NaN                              1           85.0   \n",
       "132            NaN                              1           83.0   \n",
       "133            NaN                              1          124.0   \n",
       "134            NaN                              1          130.0   \n",
       "135            NaN                              3          106.0   \n",
       "136            NaN                              3           81.0   \n",
       "137            NaN                              1           91.6   \n",
       "138            NaN                              1          142.0   \n",
       "139            NaN                              1           80.0   \n",
       "\n",
       "     OC_mode_cylinder_number  OC_mode_engine_torque  OC_mode_car_length  \\\n",
       "0                        4.0                  150.7                4270   \n",
       "1                        4.0                  230.0                4650   \n",
       "2                        4.0                  225.0                5213   \n",
       "3                        4.0                  190.0                4825   \n",
       "4                        4.0                  215.0                4715   \n",
       "5                        4.0                  155.0                4473   \n",
       "6                        4.0                   85.0                3730   \n",
       "7                        4.0                  146.0                4370   \n",
       "8                        4.0                  132.4                4240   \n",
       "9                        4.0                  265.0                4475   \n",
       "10                       4.0                  140.0                4547   \n",
       "11                       4.0                  146.0                4718   \n",
       "12                       4.0                  310.0                5055   \n",
       "13                       4.0                  210.0                4335   \n",
       "14                       4.0                  250.0                4385   \n",
       "15                       4.0                  225.0                4348   \n",
       "16                       4.0                  135.0                4370   \n",
       "17                       4.0                  200.0                4672   \n",
       "18                       4.0                  252.0                4923   \n",
       "19                       4.0                  135.0                4360   \n",
       "20                       4.0                  146.5                4415   \n",
       "21                       4.0                  250.0                4870   \n",
       "22                       4.0                  250.0                4462   \n",
       "23                       4.0                  148.0                4582   \n",
       "24                       4.0                  185.0                4440   \n",
       "25                       4.0                  190.0                4550   \n",
       "26                       4.0                  190.0                4843   \n",
       "27                       4.0                  160.0                4160   \n",
       "28                       4.0                  143.0                4354   \n",
       "29                       4.0                  154.0                4630   \n",
       "..                       ...                    ...                 ...   \n",
       "110                      4.0                  215.0                4534   \n",
       "111                      4.0                  201.0                4530   \n",
       "112                      4.0                  155.5                4705   \n",
       "113                      4.0                  140.0                4570   \n",
       "114                      4.0                  155.0                4440   \n",
       "115                      4.0                  250.0                4282   \n",
       "116                      4.0                  199.0                4415   \n",
       "117                      4.0                  245.0                4450   \n",
       "118                      4.0                  400.0                4748   \n",
       "119                      4.0                  172.0                4812   \n",
       "120                      4.0                  150.0                4650   \n",
       "121                      4.0                  250.0                4314   \n",
       "122                      4.0                  240.0                4671   \n",
       "123                      4.0                  360.0                4524   \n",
       "124                      4.0                  250.0                4765   \n",
       "125                      4.0                  146.5                4865   \n",
       "126                      4.0                  160.0                4220   \n",
       "127                      4.0                  200.0                4810   \n",
       "128                      4.0                  155.0                4278   \n",
       "129                      4.0                  190.0                3970   \n",
       "130                      4.0                  142.0                4869   \n",
       "131                      4.0                  150.0                4587   \n",
       "132                      4.0                  250.0                4520   \n",
       "133                      4.0                  265.0                4545   \n",
       "134                      4.0                  198.0                4480   \n",
       "135                      4.0                  160.0                4315   \n",
       "136                      4.0                  150.7                4487   \n",
       "137                      4.0                  243.0                4270   \n",
       "138                      4.0                  140.0                4816   \n",
       "139                      4.0                    NaN                4631   \n",
       "\n",
       "               ...              OC_mode_driven_type_id_2  \\\n",
       "0              ...                                   NaN   \n",
       "1              ...                                   NaN   \n",
       "2              ...                                   NaN   \n",
       "3              ...                                   NaN   \n",
       "4              ...                                   NaN   \n",
       "5              ...                                   NaN   \n",
       "6              ...                                   1.0   \n",
       "7              ...                                   NaN   \n",
       "8              ...                                   NaN   \n",
       "9              ...                                   NaN   \n",
       "10             ...                                   NaN   \n",
       "11             ...                                   NaN   \n",
       "12             ...                                   1.0   \n",
       "13             ...                                   NaN   \n",
       "14             ...                                   NaN   \n",
       "15             ...                                   NaN   \n",
       "16             ...                                   NaN   \n",
       "17             ...                                   NaN   \n",
       "18             ...                                   NaN   \n",
       "19             ...                                   1.0   \n",
       "20             ...                                   1.0   \n",
       "21             ...                                   NaN   \n",
       "22             ...                                   NaN   \n",
       "23             ...                                   NaN   \n",
       "24             ...                                   NaN   \n",
       "25             ...                                   NaN   \n",
       "26             ...                                   NaN   \n",
       "27             ...                                   NaN   \n",
       "28             ...                                   NaN   \n",
       "29             ...                                   NaN   \n",
       "..             ...                                   ...   \n",
       "110            ...                                   NaN   \n",
       "111            ...                                   NaN   \n",
       "112            ...                                   NaN   \n",
       "113            ...                                   NaN   \n",
       "114            ...                                   NaN   \n",
       "115            ...                                   NaN   \n",
       "116            ...                                   NaN   \n",
       "117            ...                                   NaN   \n",
       "118            ...                                   NaN   \n",
       "119            ...                                   NaN   \n",
       "120            ...                                   NaN   \n",
       "121            ...                                   NaN   \n",
       "122            ...                                   NaN   \n",
       "123            ...                                   NaN   \n",
       "124            ...                                   NaN   \n",
       "125            ...                                   NaN   \n",
       "126            ...                                   NaN   \n",
       "127            ...                                   NaN   \n",
       "128            ...                                   NaN   \n",
       "129            ...                                   NaN   \n",
       "130            ...                                   NaN   \n",
       "131            ...                                   NaN   \n",
       "132            ...                                   1.0   \n",
       "133            ...                                   NaN   \n",
       "134            ...                                   NaN   \n",
       "135            ...                                   NaN   \n",
       "136            ...                                   NaN   \n",
       "137            ...                                   NaN   \n",
       "138            ...                                   NaN   \n",
       "139            ...                                   NaN   \n",
       "\n",
       "     OC_mode_driven_type_id_3  OC_mode_fuel_type_id_1.0  \\\n",
       "0                         NaN                       1.0   \n",
       "1                         NaN                       1.0   \n",
       "2                         NaN                       1.0   \n",
       "3                         NaN                       1.0   \n",
       "4                         NaN                       1.0   \n",
       "5                         NaN                       1.0   \n",
       "6                         NaN                       1.0   \n",
       "7                         NaN                       1.0   \n",
       "8                         NaN                       1.0   \n",
       "9                         NaN                       1.0   \n",
       "10                        NaN                       1.0   \n",
       "11                        NaN                       1.0   \n",
       "12                        NaN                       1.0   \n",
       "13                        NaN                       1.0   \n",
       "14                        NaN                       1.0   \n",
       "15                        NaN                       1.0   \n",
       "16                        NaN                       1.0   \n",
       "17                        NaN                       1.0   \n",
       "18                        NaN                       1.0   \n",
       "19                        NaN                       1.0   \n",
       "20                        NaN                       1.0   \n",
       "21                        NaN                       1.0   \n",
       "22                        NaN                       1.0   \n",
       "23                        NaN                       1.0   \n",
       "24                        NaN                       1.0   \n",
       "25                        NaN                       1.0   \n",
       "26                        NaN                       1.0   \n",
       "27                        NaN                       1.0   \n",
       "28                        NaN                       1.0   \n",
       "29                        NaN                       1.0   \n",
       "..                        ...                       ...   \n",
       "110                       NaN                       1.0   \n",
       "111                       NaN                       1.0   \n",
       "112                       NaN                       1.0   \n",
       "113                       NaN                       1.0   \n",
       "114                       NaN                       1.0   \n",
       "115                       NaN                       1.0   \n",
       "116                       NaN                       1.0   \n",
       "117                       NaN                       1.0   \n",
       "118                       NaN                       1.0   \n",
       "119                       NaN                       1.0   \n",
       "120                       NaN                       1.0   \n",
       "121                       NaN                       1.0   \n",
       "122                       NaN                       1.0   \n",
       "123                       NaN                       1.0   \n",
       "124                       NaN                       1.0   \n",
       "125                       NaN                       1.0   \n",
       "126                       NaN                       1.0   \n",
       "127                       NaN                       1.0   \n",
       "128                       NaN                       1.0   \n",
       "129                       NaN                       1.0   \n",
       "130                       NaN                       1.0   \n",
       "131                       NaN                       1.0   \n",
       "132                       NaN                       1.0   \n",
       "133                       NaN                       1.0   \n",
       "134                       NaN                       1.0   \n",
       "135                       NaN                       1.0   \n",
       "136                       NaN                       1.0   \n",
       "137                       NaN                       1.0   \n",
       "138                       NaN                       1.0   \n",
       "139                       NaN                       1.0   \n",
       "\n",
       "     OC_mode_fuel_type_id_4.0  OC_mode_newenergy_type_id_1  \\\n",
       "0                         NaN                          1.0   \n",
       "1                         NaN                          1.0   \n",
       "2                         NaN                          1.0   \n",
       "3                         NaN                          1.0   \n",
       "4                         NaN                          1.0   \n",
       "5                         NaN                          1.0   \n",
       "6                         NaN                          1.0   \n",
       "7                         NaN                          1.0   \n",
       "8                         NaN                          1.0   \n",
       "9                         NaN                          1.0   \n",
       "10                        NaN                          1.0   \n",
       "11                        NaN                          1.0   \n",
       "12                        NaN                          1.0   \n",
       "13                        NaN                          1.0   \n",
       "14                        NaN                          1.0   \n",
       "15                        NaN                          1.0   \n",
       "16                        NaN                          1.0   \n",
       "17                        NaN                          1.0   \n",
       "18                        NaN                          1.0   \n",
       "19                        NaN                          1.0   \n",
       "20                        NaN                          1.0   \n",
       "21                        NaN                          1.0   \n",
       "22                        NaN                          1.0   \n",
       "23                        NaN                          1.0   \n",
       "24                        NaN                          1.0   \n",
       "25                        NaN                          1.0   \n",
       "26                        NaN                          1.0   \n",
       "27                        NaN                          1.0   \n",
       "28                        NaN                          1.0   \n",
       "29                        NaN                          1.0   \n",
       "..                        ...                          ...   \n",
       "110                       NaN                          1.0   \n",
       "111                       NaN                          1.0   \n",
       "112                       NaN                          1.0   \n",
       "113                       NaN                          1.0   \n",
       "114                       NaN                          1.0   \n",
       "115                       NaN                          1.0   \n",
       "116                       NaN                          1.0   \n",
       "117                       NaN                          1.0   \n",
       "118                       NaN                          1.0   \n",
       "119                       NaN                          1.0   \n",
       "120                       NaN                          1.0   \n",
       "121                       NaN                          1.0   \n",
       "122                       NaN                          1.0   \n",
       "123                       NaN                          1.0   \n",
       "124                       NaN                          1.0   \n",
       "125                       NaN                          1.0   \n",
       "126                       NaN                          1.0   \n",
       "127                       NaN                          1.0   \n",
       "128                       NaN                          1.0   \n",
       "129                       NaN                          1.0   \n",
       "130                       NaN                          1.0   \n",
       "131                       NaN                          1.0   \n",
       "132                       NaN                          1.0   \n",
       "133                       NaN                          1.0   \n",
       "134                       NaN                          1.0   \n",
       "135                       NaN                          1.0   \n",
       "136                       NaN                          1.0   \n",
       "137                       NaN                          1.0   \n",
       "138                       NaN                          1.0   \n",
       "139                       NaN                          1.0   \n",
       "\n",
       "     OC_mode_newenergy_type_id_3  OC_mode_if_MPV_id_1  OC_mode_if_MPV_id_2  \\\n",
       "0                            NaN                  NaN                  1.0   \n",
       "1                            NaN                  NaN                  1.0   \n",
       "2                            NaN                  NaN                  1.0   \n",
       "3                            NaN                  NaN                  1.0   \n",
       "4                            NaN                  NaN                  1.0   \n",
       "5                            NaN                  NaN                  1.0   \n",
       "6                            NaN                  NaN                  1.0   \n",
       "7                            NaN                  NaN                  1.0   \n",
       "8                            NaN                  NaN                  1.0   \n",
       "9                            NaN                  NaN                  1.0   \n",
       "10                           NaN                  NaN                  1.0   \n",
       "11                           NaN                  NaN                  1.0   \n",
       "12                           NaN                  NaN                  1.0   \n",
       "13                           NaN                  NaN                  1.0   \n",
       "14                           NaN                  NaN                  1.0   \n",
       "15                           NaN                  NaN                  1.0   \n",
       "16                           NaN                  NaN                  1.0   \n",
       "17                           NaN                  NaN                  1.0   \n",
       "18                           NaN                  NaN                  1.0   \n",
       "19                           NaN                  1.0                  NaN   \n",
       "20                           NaN                  1.0                  NaN   \n",
       "21                           NaN                  NaN                  1.0   \n",
       "22                           NaN                  NaN                  1.0   \n",
       "23                           NaN                  NaN                  1.0   \n",
       "24                           NaN                  NaN                  1.0   \n",
       "25                           NaN                  NaN                  1.0   \n",
       "26                           NaN                  NaN                  1.0   \n",
       "27                           NaN                  NaN                  1.0   \n",
       "28                           NaN                  NaN                  1.0   \n",
       "29                           NaN                  NaN                  1.0   \n",
       "..                           ...                  ...                  ...   \n",
       "110                          NaN                  NaN                  1.0   \n",
       "111                          NaN                  NaN                  1.0   \n",
       "112                          NaN                  NaN                  1.0   \n",
       "113                          NaN                  NaN                  1.0   \n",
       "114                          NaN                  NaN                  1.0   \n",
       "115                          NaN                  NaN                  1.0   \n",
       "116                          NaN                  NaN                  1.0   \n",
       "117                          NaN                  NaN                  1.0   \n",
       "118                          NaN                  NaN                  1.0   \n",
       "119                          NaN                  NaN                  1.0   \n",
       "120                          NaN                  NaN                  1.0   \n",
       "121                          NaN                  NaN                  1.0   \n",
       "122                          NaN                  NaN                  1.0   \n",
       "123                          NaN                  NaN                  1.0   \n",
       "124                          NaN                  NaN                  1.0   \n",
       "125                          NaN                  NaN                  1.0   \n",
       "126                          NaN                  NaN                  1.0   \n",
       "127                          NaN                  NaN                  1.0   \n",
       "128                          NaN                  NaN                  1.0   \n",
       "129                          NaN                  NaN                  1.0   \n",
       "130                          NaN                  NaN                  1.0   \n",
       "131                          NaN                  NaN                  1.0   \n",
       "132                          NaN                  NaN                  1.0   \n",
       "133                          NaN                  NaN                  1.0   \n",
       "134                          NaN                  NaN                  1.0   \n",
       "135                          NaN                  NaN                  1.0   \n",
       "136                          NaN                  NaN                  1.0   \n",
       "137                          NaN                  NaN                  1.0   \n",
       "138                          NaN                  NaN                  1.0   \n",
       "139                          NaN                  NaN                  1.0   \n",
       "\n",
       "     OC_mode_if_luxurious_id_1  OC_mode_if_luxurious_id_2  \n",
       "0                          1.0                        NaN  \n",
       "1                          1.0                        NaN  \n",
       "2                          1.0                        NaN  \n",
       "3                          1.0                        NaN  \n",
       "4                          1.0                        NaN  \n",
       "5                          1.0                        NaN  \n",
       "6                          1.0                        NaN  \n",
       "7                          1.0                        NaN  \n",
       "8                          1.0                        NaN  \n",
       "9                          1.0                        NaN  \n",
       "10                         1.0                        NaN  \n",
       "11                         1.0                        NaN  \n",
       "12                         NaN                        1.0  \n",
       "13                         1.0                        NaN  \n",
       "14                         NaN                        1.0  \n",
       "15                         1.0                        NaN  \n",
       "16                         1.0                        NaN  \n",
       "17                         1.0                        NaN  \n",
       "18                         1.0                        NaN  \n",
       "19                         1.0                        NaN  \n",
       "20                         1.0                        NaN  \n",
       "21                         1.0                        NaN  \n",
       "22                         NaN                        1.0  \n",
       "23                         1.0                        NaN  \n",
       "24                         1.0                        NaN  \n",
       "25                         1.0                        NaN  \n",
       "26                         1.0                        NaN  \n",
       "27                         1.0                        NaN  \n",
       "28                         1.0                        NaN  \n",
       "29                         1.0                        NaN  \n",
       "..                         ...                        ...  \n",
       "110                        1.0                        NaN  \n",
       "111                        1.0                        NaN  \n",
       "112                        1.0                        NaN  \n",
       "113                        1.0                        NaN  \n",
       "114                        1.0                        NaN  \n",
       "115                        1.0                        NaN  \n",
       "116                        1.0                        NaN  \n",
       "117                        1.0                        NaN  \n",
       "118                        1.0                        NaN  \n",
       "119                        NaN                        1.0  \n",
       "120                        1.0                        NaN  \n",
       "121                        1.0                        NaN  \n",
       "122                        1.0                        NaN  \n",
       "123                        1.0                        NaN  \n",
       "124                        1.0                        NaN  \n",
       "125                        1.0                        NaN  \n",
       "126                        1.0                        NaN  \n",
       "127                        1.0                        NaN  \n",
       "128                        1.0                        NaN  \n",
       "129                        1.0                        NaN  \n",
       "130                        1.0                        NaN  \n",
       "131                        1.0                        NaN  \n",
       "132                        1.0                        NaN  \n",
       "133                        1.0                        NaN  \n",
       "134                        1.0                        NaN  \n",
       "135                        1.0                        NaN  \n",
       "136                        1.0                        NaN  \n",
       "137                        1.0                        NaN  \n",
       "138                        1.0                        NaN  \n",
       "139                        1.0                        NaN  \n",
       "\n",
       "[140 rows x 223 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_OC"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "features = pd.merge(df_CB, df_OC, how='left', on='class_id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>class_id</th>\n",
       "      <th>sale_date</th>\n",
       "      <th>sale_quantity</th>\n",
       "      <th>C_som_1</th>\n",
       "      <th>C_som_2</th>\n",
       "      <th>C_som_3</th>\n",
       "      <th>C_som_4</th>\n",
       "      <th>C_som_5</th>\n",
       "      <th>C_som_6</th>\n",
       "      <th>C_som_7</th>\n",
       "      <th>...</th>\n",
       "      <th>OC_mode_driven_type_id_2</th>\n",
       "      <th>OC_mode_driven_type_id_3</th>\n",
       "      <th>OC_mode_fuel_type_id_1.0</th>\n",
       "      <th>OC_mode_fuel_type_id_4.0</th>\n",
       "      <th>OC_mode_newenergy_type_id_1</th>\n",
       "      <th>OC_mode_newenergy_type_id_3</th>\n",
       "      <th>OC_mode_if_MPV_id_1</th>\n",
       "      <th>OC_mode_if_MPV_id_2</th>\n",
       "      <th>OC_mode_if_luxurious_id_1</th>\n",
       "      <th>OC_mode_if_luxurious_id_2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-03-01</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-04-01</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-05-01</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-06-01</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-07-01</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-08-01</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-09-01</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-10-01</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-11-01</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>103507</td>\n",
       "      <td>2015-12-01</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-02-01</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-03-01</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-04-01</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-05-01</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-08-01</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-10-01</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-11-01</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>103507</td>\n",
       "      <td>2016-12-01</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>772.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>829.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-02-01</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-03-01</td>\n",
       "      <td>371.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-04-01</td>\n",
       "      <td>290.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-05-01</td>\n",
       "      <td>429.0</td>\n",
       "      <td>290.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>632.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-06-01</td>\n",
       "      <td>371.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>290.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-07-01</td>\n",
       "      <td>313.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>290.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>1653.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>103507</td>\n",
       "      <td>2017-08-01</td>\n",
       "      <td>180.0</td>\n",
       "      <td>313.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>290.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5697</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-06-01</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>799.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>439.0</td>\n",
       "      <td>447.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5698</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-07-01</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>799.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>439.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5699</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-08-01</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>799.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5700</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-09-01</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>799.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5701</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-10-01</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5702</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-11-01</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5703</th>\n",
       "      <td>978089</td>\n",
       "      <td>2015-12-01</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5704</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5705</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-02-01</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5706</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-03-01</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5707</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-04-01</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>753.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5708</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-05-01</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5709</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5710</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>1284.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5711</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-08-01</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5712</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>623.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5713</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-10-01</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5714</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-11-01</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>604.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5715</th>\n",
       "      <td>978089</td>\n",
       "      <td>2016-12-01</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5716</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5717</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-02-01</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5718</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-03-01</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5719</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-04-01</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5720</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-05-01</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>503.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5721</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-06-01</td>\n",
       "      <td>381.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5722</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-07-01</td>\n",
       "      <td>270.0</td>\n",
       "      <td>381.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5723</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-08-01</td>\n",
       "      <td>419.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>381.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5724</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-09-01</td>\n",
       "      <td>401.0</td>\n",
       "      <td>419.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>381.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5725</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-10-01</td>\n",
       "      <td>400.0</td>\n",
       "      <td>401.0</td>\n",
       "      <td>419.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>381.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5726</th>\n",
       "      <td>978089</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>400.0</td>\n",
       "      <td>401.0</td>\n",
       "      <td>419.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>381.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5727 rows × 1678 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      class_id  sale_date  sale_quantity  C_som_1  C_som_2  C_som_3  C_som_4  \\\n",
       "0       103507 2015-03-01           58.0      NaN      NaN      NaN      NaN   \n",
       "1       103507 2015-04-01          232.0     58.0      NaN      NaN      NaN   \n",
       "2       103507 2015-05-01          226.0    232.0     58.0      NaN      NaN   \n",
       "3       103507 2015-06-01          286.0    226.0    232.0     58.0      NaN   \n",
       "4       103507 2015-07-01          297.0    286.0    226.0    232.0     58.0   \n",
       "5       103507 2015-08-01          355.0    297.0    286.0    226.0    232.0   \n",
       "6       103507 2015-09-01          442.0    355.0    297.0    286.0    226.0   \n",
       "7       103507 2015-10-01         1050.0    442.0    355.0    297.0    286.0   \n",
       "8       103507 2015-11-01          481.0   1050.0    442.0    355.0    297.0   \n",
       "9       103507 2015-12-01         1433.0    481.0   1050.0    442.0    355.0   \n",
       "10      103507 2016-01-01          993.0   1433.0    481.0   1050.0    442.0   \n",
       "11      103507 2016-02-01          953.0    993.0   1433.0    481.0   1050.0   \n",
       "12      103507 2016-03-01          650.0    953.0    993.0   1433.0    481.0   \n",
       "13      103507 2016-04-01          145.0    650.0    953.0    993.0   1433.0   \n",
       "14      103507 2016-05-01          772.0    145.0    650.0    953.0    993.0   \n",
       "15      103507 2016-06-01          829.0    772.0    145.0    650.0    953.0   \n",
       "16      103507 2016-07-01          378.0    829.0    772.0    145.0    650.0   \n",
       "17      103507 2016-08-01          406.0    378.0    829.0    772.0    145.0   \n",
       "18      103507 2016-09-01          684.0    406.0    378.0    829.0    772.0   \n",
       "19      103507 2016-10-01          632.0    684.0    406.0    378.0    829.0   \n",
       "20      103507 2016-11-01          876.0    632.0    684.0    406.0    378.0   \n",
       "21      103507 2016-12-01         1653.0    876.0    632.0    684.0    406.0   \n",
       "22      103507 2017-01-01          499.0   1653.0    876.0    632.0    684.0   \n",
       "23      103507 2017-02-01          435.0    499.0   1653.0    876.0    632.0   \n",
       "24      103507 2017-03-01          371.0    435.0    499.0   1653.0    876.0   \n",
       "25      103507 2017-04-01          290.0    371.0    435.0    499.0   1653.0   \n",
       "26      103507 2017-05-01          429.0    290.0    371.0    435.0    499.0   \n",
       "27      103507 2017-06-01          371.0    429.0    290.0    371.0    435.0   \n",
       "28      103507 2017-07-01          313.0    371.0    429.0    290.0    371.0   \n",
       "29      103507 2017-08-01          180.0    313.0    371.0    429.0    290.0   \n",
       "...        ...        ...            ...      ...      ...      ...      ...   \n",
       "5697    978089 2015-06-01          372.0    418.0    260.0    429.0    799.0   \n",
       "5698    978089 2015-07-01          428.0    372.0    418.0    260.0    429.0   \n",
       "5699    978089 2015-08-01          503.0    428.0    372.0    418.0    260.0   \n",
       "5700    978089 2015-09-01          753.0    503.0    428.0    372.0    418.0   \n",
       "5701    978089 2015-10-01          790.0    753.0    503.0    428.0    372.0   \n",
       "5702    978089 2015-11-01          659.0    790.0    753.0    503.0    428.0   \n",
       "5703    978089 2015-12-01         1284.0    659.0    790.0    753.0    503.0   \n",
       "5704    978089 2016-01-01          651.0   1284.0    659.0    790.0    753.0   \n",
       "5705    978089 2016-02-01          623.0    651.0   1284.0    659.0    790.0   \n",
       "5706    978089 2016-03-01          605.0    623.0    651.0   1284.0    659.0   \n",
       "5707    978089 2016-04-01          604.0    605.0    623.0    651.0   1284.0   \n",
       "5708    978089 2016-05-01          735.0    604.0    605.0    623.0    651.0   \n",
       "5709    978089 2016-06-01          474.0    735.0    604.0    605.0    623.0   \n",
       "5710    978089 2016-07-01          530.0    474.0    735.0    604.0    605.0   \n",
       "5711    978089 2016-08-01          521.0    530.0    474.0    735.0    604.0   \n",
       "5712    978089 2016-09-01          474.0    521.0    530.0    474.0    735.0   \n",
       "5713    978089 2016-10-01          503.0    474.0    521.0    530.0    474.0   \n",
       "5714    978089 2016-11-01          400.0    503.0    474.0    521.0    530.0   \n",
       "5715    978089 2016-12-01         1042.0    400.0    503.0    474.0    521.0   \n",
       "5716    978089 2017-01-01          558.0   1042.0    400.0    503.0    474.0   \n",
       "5717    978089 2017-02-01          494.0    558.0   1042.0    400.0    503.0   \n",
       "5718    978089 2017-03-01          548.0    494.0    558.0   1042.0    400.0   \n",
       "5719    978089 2017-04-01          466.0    548.0    494.0    558.0   1042.0   \n",
       "5720    978089 2017-05-01          512.0    466.0    548.0    494.0    558.0   \n",
       "5721    978089 2017-06-01          381.0    512.0    466.0    548.0    494.0   \n",
       "5722    978089 2017-07-01          270.0    381.0    512.0    466.0    548.0   \n",
       "5723    978089 2017-08-01          419.0    270.0    381.0    512.0    466.0   \n",
       "5724    978089 2017-09-01          401.0    419.0    270.0    381.0    512.0   \n",
       "5725    978089 2017-10-01          400.0    401.0    419.0    270.0    381.0   \n",
       "5726    978089 2017-11-01            NaN    400.0    401.0    419.0    270.0   \n",
       "\n",
       "      C_som_5  C_som_6  C_som_7            ...              \\\n",
       "0         NaN      NaN      NaN            ...               \n",
       "1         NaN      NaN      NaN            ...               \n",
       "2         NaN      NaN      NaN            ...               \n",
       "3         NaN      NaN      NaN            ...               \n",
       "4         NaN      NaN      NaN            ...               \n",
       "5        58.0      NaN      NaN            ...               \n",
       "6       232.0     58.0      NaN            ...               \n",
       "7       226.0    232.0     58.0            ...               \n",
       "8       286.0    226.0    232.0            ...               \n",
       "9       297.0    286.0    226.0            ...               \n",
       "10      355.0    297.0    286.0            ...               \n",
       "11      442.0    355.0    297.0            ...               \n",
       "12     1050.0    442.0    355.0            ...               \n",
       "13      481.0   1050.0    442.0            ...               \n",
       "14     1433.0    481.0   1050.0            ...               \n",
       "15      993.0   1433.0    481.0            ...               \n",
       "16      953.0    993.0   1433.0            ...               \n",
       "17      650.0    953.0    993.0            ...               \n",
       "18      145.0    650.0    953.0            ...               \n",
       "19      772.0    145.0    650.0            ...               \n",
       "20      829.0    772.0    145.0            ...               \n",
       "21      378.0    829.0    772.0            ...               \n",
       "22      406.0    378.0    829.0            ...               \n",
       "23      684.0    406.0    378.0            ...               \n",
       "24      632.0    684.0    406.0            ...               \n",
       "25      876.0    632.0    684.0            ...               \n",
       "26     1653.0    876.0    632.0            ...               \n",
       "27      499.0   1653.0    876.0            ...               \n",
       "28      435.0    499.0   1653.0            ...               \n",
       "29      371.0    435.0    499.0            ...               \n",
       "...       ...      ...      ...            ...               \n",
       "5697    800.0    439.0    447.0            ...               \n",
       "5698    799.0    800.0    439.0            ...               \n",
       "5699    429.0    799.0    800.0            ...               \n",
       "5700    260.0    429.0    799.0            ...               \n",
       "5701    418.0    260.0    429.0            ...               \n",
       "5702    372.0    418.0    260.0            ...               \n",
       "5703    428.0    372.0    418.0            ...               \n",
       "5704    503.0    428.0    372.0            ...               \n",
       "5705    753.0    503.0    428.0            ...               \n",
       "5706    790.0    753.0    503.0            ...               \n",
       "5707    659.0    790.0    753.0            ...               \n",
       "5708   1284.0    659.0    790.0            ...               \n",
       "5709    651.0   1284.0    659.0            ...               \n",
       "5710    623.0    651.0   1284.0            ...               \n",
       "5711    605.0    623.0    651.0            ...               \n",
       "5712    604.0    605.0    623.0            ...               \n",
       "5713    735.0    604.0    605.0            ...               \n",
       "5714    474.0    735.0    604.0            ...               \n",
       "5715    530.0    474.0    735.0            ...               \n",
       "5716    521.0    530.0    474.0            ...               \n",
       "5717    474.0    521.0    530.0            ...               \n",
       "5718    503.0    474.0    521.0            ...               \n",
       "5719    400.0    503.0    474.0            ...               \n",
       "5720   1042.0    400.0    503.0            ...               \n",
       "5721    558.0   1042.0    400.0            ...               \n",
       "5722    494.0    558.0   1042.0            ...               \n",
       "5723    548.0    494.0    558.0            ...               \n",
       "5724    466.0    548.0    494.0            ...               \n",
       "5725    512.0    466.0    548.0            ...               \n",
       "5726    381.0    512.0    466.0            ...               \n",
       "\n",
       "      OC_mode_driven_type_id_2  OC_mode_driven_type_id_3  \\\n",
       "0                          NaN                       NaN   \n",
       "1                          NaN                       NaN   \n",
       "2                          NaN                       NaN   \n",
       "3                          NaN                       NaN   \n",
       "4                          NaN                       NaN   \n",
       "5                          NaN                       NaN   \n",
       "6                          NaN                       NaN   \n",
       "7                          NaN                       NaN   \n",
       "8                          NaN                       NaN   \n",
       "9                          NaN                       NaN   \n",
       "10                         NaN                       NaN   \n",
       "11                         NaN                       NaN   \n",
       "12                         NaN                       NaN   \n",
       "13                         NaN                       NaN   \n",
       "14                         NaN                       NaN   \n",
       "15                         NaN                       NaN   \n",
       "16                         NaN                       NaN   \n",
       "17                         NaN                       NaN   \n",
       "18                         NaN                       NaN   \n",
       "19                         NaN                       NaN   \n",
       "20                         NaN                       NaN   \n",
       "21                         NaN                       NaN   \n",
       "22                         NaN                       NaN   \n",
       "23                         NaN                       NaN   \n",
       "24                         NaN                       NaN   \n",
       "25                         NaN                       NaN   \n",
       "26                         NaN                       NaN   \n",
       "27                         NaN                       NaN   \n",
       "28                         NaN                       NaN   \n",
       "29                         NaN                       NaN   \n",
       "...                        ...                       ...   \n",
       "5697                       NaN                       NaN   \n",
       "5698                       NaN                       NaN   \n",
       "5699                       NaN                       NaN   \n",
       "5700                       NaN                       NaN   \n",
       "5701                       NaN                       NaN   \n",
       "5702                       NaN                       NaN   \n",
       "5703                       NaN                       NaN   \n",
       "5704                       NaN                       NaN   \n",
       "5705                       NaN                       NaN   \n",
       "5706                       NaN                       NaN   \n",
       "5707                       NaN                       NaN   \n",
       "5708                       NaN                       NaN   \n",
       "5709                       NaN                       NaN   \n",
       "5710                       NaN                       NaN   \n",
       "5711                       NaN                       NaN   \n",
       "5712                       NaN                       NaN   \n",
       "5713                       NaN                       NaN   \n",
       "5714                       NaN                       NaN   \n",
       "5715                       NaN                       NaN   \n",
       "5716                       NaN                       NaN   \n",
       "5717                       NaN                       NaN   \n",
       "5718                       NaN                       NaN   \n",
       "5719                       NaN                       NaN   \n",
       "5720                       NaN                       NaN   \n",
       "5721                       NaN                       NaN   \n",
       "5722                       NaN                       NaN   \n",
       "5723                       NaN                       NaN   \n",
       "5724                       NaN                       NaN   \n",
       "5725                       NaN                       NaN   \n",
       "5726                       NaN                       NaN   \n",
       "\n",
       "      OC_mode_fuel_type_id_1.0  OC_mode_fuel_type_id_4.0  \\\n",
       "0                          1.0                       NaN   \n",
       "1                          1.0                       NaN   \n",
       "2                          1.0                       NaN   \n",
       "3                          1.0                       NaN   \n",
       "4                          1.0                       NaN   \n",
       "5                          1.0                       NaN   \n",
       "6                          1.0                       NaN   \n",
       "7                          1.0                       NaN   \n",
       "8                          1.0                       NaN   \n",
       "9                          1.0                       NaN   \n",
       "10                         1.0                       NaN   \n",
       "11                         1.0                       NaN   \n",
       "12                         1.0                       NaN   \n",
       "13                         1.0                       NaN   \n",
       "14                         1.0                       NaN   \n",
       "15                         1.0                       NaN   \n",
       "16                         1.0                       NaN   \n",
       "17                         1.0                       NaN   \n",
       "18                         1.0                       NaN   \n",
       "19                         1.0                       NaN   \n",
       "20                         1.0                       NaN   \n",
       "21                         1.0                       NaN   \n",
       "22                         1.0                       NaN   \n",
       "23                         1.0                       NaN   \n",
       "24                         1.0                       NaN   \n",
       "25                         1.0                       NaN   \n",
       "26                         1.0                       NaN   \n",
       "27                         1.0                       NaN   \n",
       "28                         1.0                       NaN   \n",
       "29                         1.0                       NaN   \n",
       "...                        ...                       ...   \n",
       "5697                       1.0                       NaN   \n",
       "5698                       1.0                       NaN   \n",
       "5699                       1.0                       NaN   \n",
       "5700                       1.0                       NaN   \n",
       "5701                       1.0                       NaN   \n",
       "5702                       1.0                       NaN   \n",
       "5703                       1.0                       NaN   \n",
       "5704                       1.0                       NaN   \n",
       "5705                       1.0                       NaN   \n",
       "5706                       1.0                       NaN   \n",
       "5707                       1.0                       NaN   \n",
       "5708                       1.0                       NaN   \n",
       "5709                       1.0                       NaN   \n",
       "5710                       1.0                       NaN   \n",
       "5711                       1.0                       NaN   \n",
       "5712                       1.0                       NaN   \n",
       "5713                       1.0                       NaN   \n",
       "5714                       1.0                       NaN   \n",
       "5715                       1.0                       NaN   \n",
       "5716                       1.0                       NaN   \n",
       "5717                       1.0                       NaN   \n",
       "5718                       1.0                       NaN   \n",
       "5719                       1.0                       NaN   \n",
       "5720                       1.0                       NaN   \n",
       "5721                       1.0                       NaN   \n",
       "5722                       1.0                       NaN   \n",
       "5723                       1.0                       NaN   \n",
       "5724                       1.0                       NaN   \n",
       "5725                       1.0                       NaN   \n",
       "5726                       1.0                       NaN   \n",
       "\n",
       "      OC_mode_newenergy_type_id_1  OC_mode_newenergy_type_id_3  \\\n",
       "0                             1.0                          NaN   \n",
       "1                             1.0                          NaN   \n",
       "2                             1.0                          NaN   \n",
       "3                             1.0                          NaN   \n",
       "4                             1.0                          NaN   \n",
       "5                             1.0                          NaN   \n",
       "6                             1.0                          NaN   \n",
       "7                             1.0                          NaN   \n",
       "8                             1.0                          NaN   \n",
       "9                             1.0                          NaN   \n",
       "10                            1.0                          NaN   \n",
       "11                            1.0                          NaN   \n",
       "12                            1.0                          NaN   \n",
       "13                            1.0                          NaN   \n",
       "14                            1.0                          NaN   \n",
       "15                            1.0                          NaN   \n",
       "16                            1.0                          NaN   \n",
       "17                            1.0                          NaN   \n",
       "18                            1.0                          NaN   \n",
       "19                            1.0                          NaN   \n",
       "20                            1.0                          NaN   \n",
       "21                            1.0                          NaN   \n",
       "22                            1.0                          NaN   \n",
       "23                            1.0                          NaN   \n",
       "24                            1.0                          NaN   \n",
       "25                            1.0                          NaN   \n",
       "26                            1.0                          NaN   \n",
       "27                            1.0                          NaN   \n",
       "28                            1.0                          NaN   \n",
       "29                            1.0                          NaN   \n",
       "...                           ...                          ...   \n",
       "5697                          1.0                          NaN   \n",
       "5698                          1.0                          NaN   \n",
       "5699                          1.0                          NaN   \n",
       "5700                          1.0                          NaN   \n",
       "5701                          1.0                          NaN   \n",
       "5702                          1.0                          NaN   \n",
       "5703                          1.0                          NaN   \n",
       "5704                          1.0                          NaN   \n",
       "5705                          1.0                          NaN   \n",
       "5706                          1.0                          NaN   \n",
       "5707                          1.0                          NaN   \n",
       "5708                          1.0                          NaN   \n",
       "5709                          1.0                          NaN   \n",
       "5710                          1.0                          NaN   \n",
       "5711                          1.0                          NaN   \n",
       "5712                          1.0                          NaN   \n",
       "5713                          1.0                          NaN   \n",
       "5714                          1.0                          NaN   \n",
       "5715                          1.0                          NaN   \n",
       "5716                          1.0                          NaN   \n",
       "5717                          1.0                          NaN   \n",
       "5718                          1.0                          NaN   \n",
       "5719                          1.0                          NaN   \n",
       "5720                          1.0                          NaN   \n",
       "5721                          1.0                          NaN   \n",
       "5722                          1.0                          NaN   \n",
       "5723                          1.0                          NaN   \n",
       "5724                          1.0                          NaN   \n",
       "5725                          1.0                          NaN   \n",
       "5726                          1.0                          NaN   \n",
       "\n",
       "      OC_mode_if_MPV_id_1  OC_mode_if_MPV_id_2  OC_mode_if_luxurious_id_1  \\\n",
       "0                     NaN                  1.0                        1.0   \n",
       "1                     NaN                  1.0                        1.0   \n",
       "2                     NaN                  1.0                        1.0   \n",
       "3                     NaN                  1.0                        1.0   \n",
       "4                     NaN                  1.0                        1.0   \n",
       "5                     NaN                  1.0                        1.0   \n",
       "6                     NaN                  1.0                        1.0   \n",
       "7                     NaN                  1.0                        1.0   \n",
       "8                     NaN                  1.0                        1.0   \n",
       "9                     NaN                  1.0                        1.0   \n",
       "10                    NaN                  1.0                        1.0   \n",
       "11                    NaN                  1.0                        1.0   \n",
       "12                    NaN                  1.0                        1.0   \n",
       "13                    NaN                  1.0                        1.0   \n",
       "14                    NaN                  1.0                        1.0   \n",
       "15                    NaN                  1.0                        1.0   \n",
       "16                    NaN                  1.0                        1.0   \n",
       "17                    NaN                  1.0                        1.0   \n",
       "18                    NaN                  1.0                        1.0   \n",
       "19                    NaN                  1.0                        1.0   \n",
       "20                    NaN                  1.0                        1.0   \n",
       "21                    NaN                  1.0                        1.0   \n",
       "22                    NaN                  1.0                        1.0   \n",
       "23                    NaN                  1.0                        1.0   \n",
       "24                    NaN                  1.0                        1.0   \n",
       "25                    NaN                  1.0                        1.0   \n",
       "26                    NaN                  1.0                        1.0   \n",
       "27                    NaN                  1.0                        1.0   \n",
       "28                    NaN                  1.0                        1.0   \n",
       "29                    NaN                  1.0                        1.0   \n",
       "...                   ...                  ...                        ...   \n",
       "5697                  NaN                  1.0                        1.0   \n",
       "5698                  NaN                  1.0                        1.0   \n",
       "5699                  NaN                  1.0                        1.0   \n",
       "5700                  NaN                  1.0                        1.0   \n",
       "5701                  NaN                  1.0                        1.0   \n",
       "5702                  NaN                  1.0                        1.0   \n",
       "5703                  NaN                  1.0                        1.0   \n",
       "5704                  NaN                  1.0                        1.0   \n",
       "5705                  NaN                  1.0                        1.0   \n",
       "5706                  NaN                  1.0                        1.0   \n",
       "5707                  NaN                  1.0                        1.0   \n",
       "5708                  NaN                  1.0                        1.0   \n",
       "5709                  NaN                  1.0                        1.0   \n",
       "5710                  NaN                  1.0                        1.0   \n",
       "5711                  NaN                  1.0                        1.0   \n",
       "5712                  NaN                  1.0                        1.0   \n",
       "5713                  NaN                  1.0                        1.0   \n",
       "5714                  NaN                  1.0                        1.0   \n",
       "5715                  NaN                  1.0                        1.0   \n",
       "5716                  NaN                  1.0                        1.0   \n",
       "5717                  NaN                  1.0                        1.0   \n",
       "5718                  NaN                  1.0                        1.0   \n",
       "5719                  NaN                  1.0                        1.0   \n",
       "5720                  NaN                  1.0                        1.0   \n",
       "5721                  NaN                  1.0                        1.0   \n",
       "5722                  NaN                  1.0                        1.0   \n",
       "5723                  NaN                  1.0                        1.0   \n",
       "5724                  NaN                  1.0                        1.0   \n",
       "5725                  NaN                  1.0                        1.0   \n",
       "5726                  NaN                  1.0                        1.0   \n",
       "\n",
       "      OC_mode_if_luxurious_id_2  \n",
       "0                           NaN  \n",
       "1                           NaN  \n",
       "2                           NaN  \n",
       "3                           NaN  \n",
       "4                           NaN  \n",
       "5                           NaN  \n",
       "6                           NaN  \n",
       "7                           NaN  \n",
       "8                           NaN  \n",
       "9                           NaN  \n",
       "10                          NaN  \n",
       "11                          NaN  \n",
       "12                          NaN  \n",
       "13                          NaN  \n",
       "14                          NaN  \n",
       "15                          NaN  \n",
       "16                          NaN  \n",
       "17                          NaN  \n",
       "18                          NaN  \n",
       "19                          NaN  \n",
       "20                          NaN  \n",
       "21                          NaN  \n",
       "22                          NaN  \n",
       "23                          NaN  \n",
       "24                          NaN  \n",
       "25                          NaN  \n",
       "26                          NaN  \n",
       "27                          NaN  \n",
       "28                          NaN  \n",
       "29                          NaN  \n",
       "...                         ...  \n",
       "5697                        NaN  \n",
       "5698                        NaN  \n",
       "5699                        NaN  \n",
       "5700                        NaN  \n",
       "5701                        NaN  \n",
       "5702                        NaN  \n",
       "5703                        NaN  \n",
       "5704                        NaN  \n",
       "5705                        NaN  \n",
       "5706                        NaN  \n",
       "5707                        NaN  \n",
       "5708                        NaN  \n",
       "5709                        NaN  \n",
       "5710                        NaN  \n",
       "5711                        NaN  \n",
       "5712                        NaN  \n",
       "5713                        NaN  \n",
       "5714                        NaN  \n",
       "5715                        NaN  \n",
       "5716                        NaN  \n",
       "5717                        NaN  \n",
       "5718                        NaN  \n",
       "5719                        NaN  \n",
       "5720                        NaN  \n",
       "5721                        NaN  \n",
       "5722                        NaN  \n",
       "5723                        NaN  \n",
       "5724                        NaN  \n",
       "5725                        NaN  \n",
       "5726                        NaN  \n",
       "\n",
       "[5727 rows x 1678 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "features"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "features.to_csv(\"../../data/features/final_features_CB+OC.csv\",index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
